﻿/*
#------------------------------------------------------------------------------
#-- Program Name:	[dbo].[spDBA_discover_server]
#-- Purpose:		Add a newly discovered database server (@server_name)
#--	Last Update:	08/23/2011
#--					For a complete history - please review comments in Version
#--					Control.
#------------------------------------------------------------------------------
*/
CREATE PROCEDURE [dbo].[spDBA_discover_server]
(
	@server_name		varchar(60)
)
AS

SET NOCOUNT ON

IF NOT EXISTS (SELECT TOP 1 * FROM dbo.tblServer WHERE srv_server_name = @server_name)
	INSERT INTO dbo.tblServer (srv_server_name, srv_date_discovered, srv_is_active)
	VALUES (@server_name, GETDATE(), 0)

SET NOCOUNT OFF
